"SQL命令未正确结束"为什么?

来源：百度知道 编辑：UC知道 时间：2024/05/14 11:27:33
select d.swjg_mc "税务机关名称",a.nsrsbh "纳税人税号",a.nsrmc from dj_nsrxx a,dm_swjg d where nsrzt_dm not in ('50') exists(select 1 from fp_pz b where b.nsrsbh=a.nsrsbh) and not exists(select 1 from fp_gpy c where c.nsrsbh=a.nsrsbh) and a.nsr_swjg_dm=d.swjg_dm order by a.nsr_swjg_dm
我在编这段程序的时候,运行的结果却是ORA-00933:SQL command not properly ended.这是什么意思？请哪位高手指点一下．

select d.swjg_mc "税务机关名称",a.nsrsbh "纳税人税号",a.nsrmc from dj_nsrxx a,dm_swjg d where nsrzt_dm not in ('50') AND exists(select 1 from fp_pz b where b.nsrsbh=a.nsrsbh) and not exists(select 1 from fp_gpy c where c.nsrsbh=a.nsrsbh) and a.nsr_swjg_dm=d.swjg_dm order by a.nsr_swjg_dm

上面的大写的 AND 是我加的

另外，还需要有取别名的关键字as
select d.swjg_mc AS "税务机关名称",a.nsrsbh AS "纳税人税号",a.nsrmc from dj_nsrxx a,dm_swjg d where nsrzt_dm not in ('50') AND exists(select 1 from fp_pz b where b.nsrsbh=a.nsrsbh) and not exists(select 1 from fp_gpy c where c.nsrsbh=a.nsrsbh) and a.nsr_swjg_dm=d.swjg_dm order by a.nsr_swjg_dm